Excel 2019 - Expert - Advanced Charting and Data Analysis
      This course is part of the MOS exam 77-728 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) Expert certification exam.      
      Trendlines and Sparklines      
      Upon successful completion you will be able to:

1. Understand Trendlines;
2. Add a Trendline to a Data Series;
3. Format Trendlines;
4. Remove Trendlines;
5. Use Trendline Forecasting;
6. Identify Other Trend Methods;
7. Add Sparklines;
8. Remove Sparklines.
      
      Dual Axes and Chart Templates      
      Upon successful completion you will be able to:

1. Add a Second Chart Axis;
2. Change Marker Colours;
3. Save Chart Templates;
4. Apply Chart Templates
5. Apply Templates to Existing Charts.		      
      Data Analysis Tools      
      Upon successful completion you will be able to:

1. Name Variable Cells;
2. Create Scenarios;
3. Select Scenario Variables;
4. Delete Scenarios;
5. Edit Scenarios;
6. Create Summary Reports;
7. Use Data Tables;
8. Use Goal Seek.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2019 - Expert - Advanced Charting and Data Analysis :
Program Training Courses - Microsoft Excel Expert 2019 :
Office Suite Training Courses - Microsoft Office 2019 / Office 365 :
© 2020 Online Training Masters